﻿CREATE TABLE [dbo].[GroupProperties] (
    [GroupPropertyID] INT            IDENTITY (1, 1) NOT NULL,
    [GroupID]         INT            NOT NULL,
    [PropertyName]    NVARCHAR (MAX) NULL,
    [PropertyValue]   NVARCHAR (MAX) NULL,
    CONSTRAINT [PK_dbo.GroupProperties] PRIMARY KEY CLUSTERED ([GroupPropertyID] ASC),
    CONSTRAINT [FK_dbo.GroupProperties_dbo.Groups_GroupID] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[Groups] ([GroupID])
);


GO
CREATE NONCLUSTERED INDEX [IX_GroupID]
    ON [dbo].[GroupProperties]([GroupID] ASC);

